StudentAwardLoanApplication

EntityType | Independent
Logical Entity Name | StudentAwardLoanApplication
Default Table Name | FaLoanApplication
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAwardLoanApplication Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
StudentId |  | INTEGER | YES |
StudentAwardLoanId |  | INTEGER | YES |
ApplicationSubmissionReason |  | CHAR(30) | YES |
IsLoanAmountUnknown |  | BIT | YES |
AwardRangeRequestedStartDate |  | SMALLDATETIME | YES |
AwardRangeRequestedEndDate |  | SMALLDATETIME | YES |
IsSixMonthDefermentOption |  | BIT | YES |
IsSchoolCreditBalanceOption |  | BIT | YES |
PreviousApplicationIdentifier |  | CHAR(10) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
IsReconsiderationEligible |  | BIT | YES |
IsPlusCounselingCompleted |  | BIT | YES |
PLUSCounselingCompleteDate |  | DATETIME | YES |
IsCreditRequirementsMet |  | BIT | YES |
IsEndorserApproved |  | BIT | YES |
PLUSCounselingExpirationDate |  | DATETIME | YES |
CODCommentCodes |  | VARCHAR(100) | YES |

StudentAwardLoanApplication Keys

Key Name | Key Type | Keys
Uk_FaLoanApplication_FaLoanApplicationID_DateLstMod | Alternate Key | Id, LastModifiedDateTime
Uk_FaLoanApplication_FaLoanApplicationID_DateAdded | Alternate Key | Id, CreatedDateTime
Uk_FaLoanApplication_FaLoanApplicationID_FaLoanID | Alternate Key | Id, StudentAwardLoanId
Uk_FaLoanApplication_FaLoanApplicationID_SyStudentID | Alternate Key | Id, StudentId
PK_FaLoanApplication_FaLoanApplicationId | PrimaryKey | Id

StudentAwardLoanApplication Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentAwardLoan | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentAwardLoanId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

StudentAwardLoanApplication Check Constraints

Check Constraint Name | CheckConstraint

StudentAwardLoanApplication Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardLoanApplication | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoanApplication | NO |  |  |

StudentAwardLoanApplication Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentAwardLoanApplication Data Movement Rules

Name | Type | Rule Text/Value